class CreateMwCatalogDataStates < ActiveRecord::Migration
  def change
    create_table :mw_catalog_data_states do |t|
      t.column :state, :string, :limit => 100
    end
    execute "INSERT INTO MW_CATALOG_DATA_STATES (state) VALUES ('Editing');"
    execute "INSERT INTO MW_CATALOG_DATA_LEVELS (level) VALUES ('Revision');"
    execute "INSERT INTO MW_CATALOG_DATA_LEVELS (level) VALUES ('Published');"
    execute "INSERT INTO MW_CATALOG_DATA_LEVELS (level) VALUES ('Unpublished');"
  end
end
